Pro SQL Server 2012 Relational Database Design and Implementation by Louis Davidson & Jessica M. Moss

Author:Louis Davidson & Jessica M. Moss
Language: eng
Format: epub
ISBN: 9781430236955
Publisher: Apress

Returning to the basics of design, every table should represent one and only one thing. When you see a column in a table by itself, there should be no question as to what it means, and you certainly shouldn’t need to go to the table and figure out what the meaning of a value is.

Some tools that implement an object-oriented view of a design tend to use this frequently, because it’s easy to implement tables such as this and use a cached object. One table means one set of methods instead of hundreds of different methods for hundreds of different objects—er, tables. (The fact that it stinks when you go to use it in the database for queries is of little consequence, because generally systems like this don’t, at least initially, intend for you to go into the database and do queries, except through special interfaces that take care of this situation for you.)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.